﻿CREATE TABLE [dbo].[Attachments] (
    [AttachmentKey]    UNIQUEIDENTIFIER NOT NULL,
    [UserKey]          UNIQUEIDENTIFIER NOT NULL,
    [AutoResponderKey] UNIQUEIDENTIFIER NOT NULL,
    [FilePath]         NVARCHAR (255)   NOT NULL,
    [RelPath]          NVARCHAR (255)   NOT NULL,
    [FileName]         NVARCHAR (100)   NOT NULL,
    [FileType]         NVARCHAR (12)    NULL,
    [FileSize]         INT              NULL,
    [IsRemoved]        BIT              NOT NULL,
    [LastModified]     DATETIME2 (7)    NULL,
    [CreatedOn]        DATETIME2 (7)    NOT NULL
);

